1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10 using System.Data.SqlClient;
11
12 namespace SoftQuanLyNhaHang.Models
13 {
14 class KhachHangMod_tbl
15 {
16 protected int IdKhachHang { get; set; }
17 protected string TenKhachHang { get; set; }
18 protected string SoDienThoai { get; set; }
19 protected string DiaChi { get; set; }
20 protected int TrangThai { get; set; }
21 protected double DiemTichLuy { get; set; }
22 protected double TongTien { get; set; }
23 protected double TienKhach { get; set; }
24 protected double TienTraLai { get; set; }
25 protected DateTime NgayMuaHang { get; set; }
26 protected string GhiChu { get; set; }
27
28 protected string TrangThaiGiaoDich { get; set; }
29
30 protected int PageSize { get; set; }
31 protected int PageIndex { get; set; }
32
33 protected string IdKhachHangStr { get; set; }
34
35 public KhachHangMod_tbl(int _IdKhachHang)
36 {
37 IdKhachHang = _IdKhachHang;
38 }
39 public KhachHangMod_tbl()
40 { }
41
42 public KhachHangMod_tbl(string _IdKhachHangStr)
43 {
44 IdKhachHangStr = _IdKhachHangStr;
45 }
46
47 public KhachHangMod_tbl(int _idKhachHang, string _soDienThoai)
48 {
49 IdKhachHang = _idKhachHang;
50 SoDienThoai = _soDienThoai;
51 }
52
53 public KhachHangMod_tbl(string _IdKhachHangStr, string _soDienThoai, string _tenKhachHang)
54 {
55 IdKhachHangStr = _IdKhachHangStr;
56 SoDienThoai = _soDienThoai;
57 TenKhachHang = _tenKhachHang;
58 }
59
60 public KhachHangMod_tbl(int _idKhachHang, string _soDienThoai, int trangThai)
61 {
62 IdKhachHang = _idKhachHang;
63 SoDienThoai = _soDienThoai;
64 TrangThai = trangThai;
65 }
66
67 public KhachHangMod_tbl(int _idKhachHang, string _tenKhachHang, string _soDienThoai, string _diaChi, int _trangThai, double _diemTichLuy, double _tongTien, double _tienKhach, double _tienTraLai, DateTime _ngayMuaHang, string _ghiChu, string _TrangThaiGiaoDich)
68 {
69
70 IdKhachHang = _idKhachHang;
71 TenKhachHang = _tenKhachHang;
72 SoDienThoai = _soDienThoai;
73 DiaChi = _diaChi;
74 TrangThai = _trangThai;
75 DiemTichLuy = _diemTichLuy;
76 TongTien = _tongTien;
77 TienKhach = _tienKhach;
78 TienTraLai = _tienTraLai;
79 NgayMuaHang = _ngayMuaHang;
80 GhiChu = _ghiChu;
81 TrangThaiGiaoDich = _TrangThaiGiaoDich;
82 }
83
84 public KhachHangMod_tbl(int _idKhachHang, string _tenKhachHang, string _soDienThoai, string _diaChi, int _trangThai, double _diemTichLuy, double _tongTien, double _tienKhach, double _tienTraLai, DateTime _ngayMuaHang, string _ghiChu, string _TrangThaiGiaoDich, int _pageSize, int _pageIndex)
85 {
86
87 IdKhachHang = _idKhachHang;
88 TenKhachHang = _tenKhachHang;
89 SoDienThoai = _soDienThoai;
90 DiaChi = _diaChi;
91 TrangThai = _trangThai;
92 DiemTichLuy = _diemTichLuy;
93 TongTien = _tongTien;
94 TienKhach = _tienKhach;
95 TienTraLai = _tienTraLai;
96 NgayMuaHang = _ngayMuaHang;
97 GhiChu = _ghiChu;
98 TrangThaiGiaoDich = _TrangThaiGiaoDich;
99 PageSize = _pageSize;
100 PageIndex = _pageIndex;
101 }
102
103 public int InsertKhachHang_tbl()
104 {
105 int i = 0;
106 string[] paras = new string[12] { "@IdKhachHang", "@TenKhachHang", "@SoDienThoai", "@DiaChi", "@TrangThai", "@DiemTichLuy", "@TongTien", "@TienKhach", "@TienTraLai", "@NgayMuaHang", "@GhiChu" , "@TrangThaiGiaoDich"};
107 object[] values = new object[12] { IdKhachHang, TenKhachHang, SoDienThoai, DiaChi, TrangThai, DiemTichLuy, TongTien, TienKhach, TienTraLai, NgayMuaHang, GhiChu, TrangThaiGiaoDich };
108 i = Int32.Parse( Models.connection.ExcuteScalar("tbl_KhachHang_Insert", CommandType.StoredProcedure, paras, values));
109
110 return i;
111 }
112 public int UpdateKhachHang_tbl()
113 {
114 int i = 0;
115 string[] paras = new string[12] { "@IdKhachHang", "@TenKhachHang", "@SoDienThoai", "@DiaChi", "@TrangThai", "@DiemTichLuy", "@TongTien", "@TienKhach", "@TienTraLai", "@NgayMuaHang", "@GhiChu", "@TrangThaiGiaoDich" };
116 object[] values = new object[12] { IdKhachHang, TenKhachHang, SoDienThoai, DiaChi, TrangThai, DiemTichLuy, TongTien, TienKhach, TienTraLai, NgayMuaHang, GhiChu, TrangThaiGiaoDich };
117 i = Models.connection.Excute_Sql("tbl_KhachHang_Update", CommandType.StoredProcedure, paras, values);
118 return i;
119 }
120 public int DeleteKhachHang_tbl()
121 {
122 int i = 0;
123 string[] paras = new string[1] { "@IdKhachHang" };
124 object[] values = new object[1] { IdKhachHang };
125 i = Models.connection.Excute_Sql("tbl_KhachHang_Delete", CommandType.StoredProcedure, paras, values);
126 return i;
127 }
128
129 public int tbl_KhachHang_Update_TrangThai()
130 {
131 int i = 0;
132 string[] paras = new string[3] { "@IdKhachHang", "@SoDienThoai", "@TrangThai"};
133 object[] values = new object[3] { IdKhachHang, SoDienThoai, TrangThai};
134 i = Models.connection.Excute_Sql("tbl_KhachHang_Update_TrangThai", CommandType.StoredProcedure, paras, values);
135 return i;
136 }
137
138 //Lấy thông tin khách hàng theo số điện thoại
139 public DataSet FillDataSet_getDiemTichLuyBySoDienThoai()
140 {
141 DataSet ds = new DataSet();
142 string[] paras = new string[2] { "@IdKhachHang", "@SoDienThoai" };
143 object[] values = new object[2] { IdKhachHang, SoDienThoai };
144 ds = Models.connection.FillDataSet("tbl_KhachHang_GetDiemTichLuyBaySoDienThoai", CommandType.StoredProcedure, paras, values);
145 return ds;
146 }
147
148 ////Lấy thông tin khách hàng theo số điện thoại va id
149 public DataSet FillDataSet_getsId_SDT()
150 {
151 DataSet ds = new DataSet();
152 string[] paras = new string[2] { "@IdKhachHang", "@SoDienThoai" };
153 object[] values = new object[2] { IdKhachHang, SoDienThoai };
154 ds = Models.connection.FillDataSet("tbl_KhachHang_GetsById_SDT", CommandType.StoredProcedure, paras, values);
155 return ds;
156 }
157
158 //lay thong tin khach hang kieu string tim kiem
159 public DataSet FillDataSet_getIdKh_TimKiem()
160 {
161 DataSet ds = new DataSet();
162 string[] paras = new string[3] { "@IdKhachHangStr", "@SoDienThoai", "@TenKhachHang" };
163 object[] values = new object[3] { IdKhachHangStr, SoDienThoai, TenKhachHang };
164 ds = Models.connection.FillDataSet("tbl_KhachHang_GetsByIdKh_TimKiem", CommandType.StoredProcedure, paras, values);
165 return ds;
166 }
167
168 //lay danh sach khach hang
169 public DataSet FillDataSet_KhachHang_BySearch()
170 {
171 DataSet ds = new DataSet();
172 string[] paras = new string[14] { "@IdKhachHang", "@TenKhachHang", "@SoDienThoai", "@DiaChi", "@TrangThai", "@DiemTichLuy", "@TongTien", "@TienKhach", "@TienTraLai", "@NgayMuaHang", "@GhiChu", "@TrangThaiGiaoDich", "@PageSize","@PageIndex" };
173 object[] values = new object[14] { IdKhachHang, TenKhachHang, SoDienThoai, DiaChi, TrangThai, DiemTichLuy, TongTien, TienKhach, TienTraLai, NgayMuaHang, GhiChu, TrangThaiGiaoDich, PageSize, PageIndex };
174 ds = Models.connection.FillDataSet("tbl_KhachHang_Search", CommandType.StoredProcedure, paras, values);
175 return ds;
176 }
177
178 //tính tổng đơn hàng trong ngày
179 public DataSet FillDataSet_KhachHang_Count_ByNgayMua()
180 {
181 DataSet ds = new DataSet();
182 string[] paras = new string[12] { "@IdKhachHang", "@TenKhachHang", "@SoDienThoai", "@DiaChi", "@TrangThai", "@DiemTichLuy", "@TongTien", "@TienKhach", "@TienTraLai", "@NgayMuaHang", "@GhiChu","@TrangThaiGiaoDich"};
183 object[] values = new object[12] { IdKhachHang, TenKhachHang, SoDienThoai, DiaChi, TrangThai, DiemTichLuy, TongTien, TienKhach, TienTraLai, NgayMuaHang, GhiChu, TrangThaiGiaoDich };
184 ds = Models.connection.FillDataSet("tbl_KhachHang_Count_ByNgayMua", CommandType.StoredProcedure, paras, values);
185 return ds;
186 }
187
188 //get khachhang
189 public DataSet FillDataSet_KhachHang_GetBy_IdKhachHang()
190 {
191 DataSet ds = new DataSet();
192 string[] paras = new string[1] { "@IdKhachHang"};
193 object[] values = new object[1] { IdKhachHang};
194 ds = Models.connection.FillDataSet("tbl_KhachHang_Get", CommandType.StoredProcedure, paras, values);
195 return ds;
196 }
197
198 //danh sach dat tra hang
199 public DataSet FillDataSet_KhachHang_DatTraHang()
200 {
201 DataSet ds = new DataSet();
202 string[] paras = new string[0] {};
203 object[] values = new object[0] {};
204 ds = Models.connection.FillDataSet("tbl_KhachHang_DatTraHang", CommandType.StoredProcedure, paras, values);
205 return ds;
206 }
207 }
208 }